Lesson: 12 - Introduction to Spreadsheet

Purpose: Learn about row, column, cell and cell address, insert / delete a row,
a column & a new sheet, rename a sheet. Properties of cell, sheet.

No. of. Classes

One class - One hour.

Materials Required

Desktop computer or Laptop computer & Open office.

Curriculum Content 7.1)Introduction to Spreadsheet.
Prior knowledge

Students should know about table & usage of the table in text document.

Exercises

Exercise:1


1. What do you mean by spreadsheet? Explain the uses of spreadsheets.

Exercise:2


2. Change the colour of cells as D13 to Green, G18 to Red and J7 to Violet.
2.1) Insert a new sheet after sheet 1 and change the name of that sheet.
2.2) Find the address of cells as they are marked in the given below screenshot.


No Image

Solutions


  • Link to view the Solution Video for Exercise-1 (Solution).
  • Link to view the Solution Video for Exercise-2 (Solution).

    • Teacher's Instruction
    1. Teach the basic and essential features of Spreadsheets.
    2. Differentiate spreadsheets and text documents.
    3. Explain about autofill feature and its usage in filling dates, days & S. No.
    4. Explain the row number and column name in Spreadsheets.
    5. Make them to understand inserting / moving / renaming a new sheet.
    6. Students should complete the exercises as a group.